package com.xiaoshuidi.cloud.module.report.dal.mapper;

import com.baomidou.mybatisplus.annotation.InterceptorIgnore;
import com.xiaoshuidi.cloud.framework.mybatis.core.mapper.BaseMapperX;
import com.xiaoshuidi.cloud.module.report.dal.DO.ContractOrderFeesDO;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

import java.math.BigDecimal;
import java.util.List;

@Mapper
@InterceptorIgnore(tenantLine = "true")
public interface ContractOrderfeesMapper extends BaseMapperX<ContractOrderFeesDO> {

    BigDecimal selectSumWaterAndElecByOrderId(@Param("orderId")Long orderId);

    BigDecimal selectDepositByOrderId(@Param("orderId")Long orderId);

    List<ContractOrderFeesDO> selectByOrderIds(@Param("orderIds") List<Long> orderIds);

    @Select("select * from contract_orderfees where order_id = #{orderId}")
    List<ContractOrderFeesDO> selectByOrderId(@Param("orderId") Long orderId);

}
